﻿CREATE TABLE [dbo].[Plant] (
    [PlantID]              BIGINT   NOT NULL,
    [PlantStrainID]        INT      NOT NULL,
    [PatientID]            BIGINT   NOT NULL,
    [PlantBatchID]         INT      NOT NULL,
    [PlantGrowLocationID]  INT      NOT NULL,
    [PlantStartDate]       DATETIME NULL,
    [PlantFlowerDate]      DATETIME NULL,
    [PlantHarvestDate]     DATETIME NULL,
    [PlantCureFinishDate]  DATETIME NULL,
    [PlantRIPDate]         DATETIME NULL,
    [PlantYield]           FLOAT    NULL,
    [ReservationDateAdded] DATETIME NULL,
    [ReservationItemPos]   SMALLINT NULL
);

